Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | ForecourtSettlementTransaction(TR_STLM_FCRT) |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | Nozzle(AS_NZL) |
FuelingPointID (FK)(PK) | A unique identifier for the FuelingPoint at a particular retail store | ID_PNT_FUEL | Identity | integer | Nozzle(AS_NZL) |
NozzleID (FK)(PK) | A unique identifier for the Nozzle | ID_NZL | Identity | integer | Nozzle(AS_NZL) |
PostpayFuelingTransactionCount | The number of PostpayFuelingTransactions performed on the LogicalNozzle during the period of time covered by the ForecourtSettlementTransaction | QU_TRN_FUEL_PSPY | QuantityTransactionCount | decimal(7,0) | |
PostpayFuelingTransactionVolume | The number of Postpay FuelingTransactions performed on the LogicalNozzle during the period of time covered by the ForecourtSettlementTransaction | QV_TRN_FUEL_PSPY | Quantity | decimal(9,2) | |
PostpayFuelingTransactionAmount | The total monetary amount of FuellingTransactions performed at the LogicalNozzle during the period of time covered by the ForecourtSettlementTransaction | MO_TRN_FUEL_PSPY | Money | decimal(16,5) | |
PrepayFuelingTransactionCount | The number of PrePayFuelingTransactions performed on the LogicalNozzle during the period of time covered by the ForecourtSettlementTransaction | QU_TRN_FUEL_PRPY | QuantityTransactionCount | decimal(7,0) | |
PrepayFuelingTransactionVolume | The number of Prepay FuelingTransactions performed on the LogicalNozzle during the period of time covered by the ForecourtSettlementTransaction | QV_TRN_FUEL_PRPY | Quantity | decimal(9,2) | |
PrepayFuelingTransactionAmount | The total monetary amount of FuellingTransactions prepaid at the LogicalNozzle during the period of time covered by the ForecourtSettlementTransaction | MO_TRN_FUEL_PRPY | Money | decimal(16,5) | |